
*********************************************
****   Description   ************************
*********************************************

*This program builds summary statistics for depositor records and the monthly panel of new accounts opened, generating Panel A of "Table 2. Deposit and Loan Datasets – Summary Statistics". 

*Individual level data are pseudo data

*********************************************
****   Registers summary stats ************** 
*********************************************


//Note that this is a pseudo dataset for depositor-level data. 
use "$Data/BankRecords_Individual_PseudoData_December2024.dta", clear 
codebook age
 
* DC Branch 
gen dc = branch == "Washington"

* Race and age 
tabstat age, stat(mean sd p25 median p75) 

* Summary stats 
tabstat dc black age occ_* open_year, statistics(mean sd p25 p50 p75) columns(statistics)  



*********************************************
****   Monthly Panel summary stats ************** 
*********************************************

//This monthly panel is the final dataset 
use "$Data/Account_Panel_Monthly_December2024.dta", clear

drop if mo_date > tm(1873m8) // restrict analysis to before FSB run 

* Branches
codebook branch

* Accounts
gen share_black = 100*(num_account_black/num_account) 
tabstat num_account num_account_black share_black, statistics(mean sd p25 p50 p75) columns(statistics)  

 
